Dashboard 04 - Township Dashboard - Creating Maps - Part 02 27


Step 2:  Create a Map visual for Apartment Zip Code



In Power BI Desktop, click on the page, ZipCode

If selected, de-select a visualization by clicking an empty area of the report page.


Visualizations

To create the following visual, copy and paste the  Average Apt. Price per Sq. Ft. map visual that was created in the 3rd dashboard, ZipCode, and use it as a template.


To create a copy of the visual, click the  Average Apt. Price per Sq. Ft. map visual , press Ctrl+C to copy, and then press Ctrl+V to paste

Paste it in the dashboard page, Township.



Fields
Under Visualizations, drag & drop it in the Location section:
Table_AptPricePerUnit_PerPricePerSqFt ->  Physical_Zip_Code



Under Visualizations, drag & drop it in the Size section:
A_KeyMeasures -> ..AVG_AptUnitPrice_PerSqFt



Under Visualizations, drag & drop it in the Tooltips section:
A_KeyMeasures ->  .YOY_Diff_AVG_AptUnitPrice_PerSqFt%
Property ->  Total_sale_Price (Set to 'Sum')
Township ->  .Township_Name
Township ->  .Township_Misc_Name




Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

Physical_Zip_Code = Zip Code

.AVG_ResidentialPrice_PerSqFt% = AVG House Price/Sq. Ft.

.YOY_Diff_AVG_ResidentialPrice_PerSqFt% = AVG House Price/Sq. Ft.
Total_sale_Price = Sale Price
.Township_Name = Township Name
.Township_Misc_Name = Township Misc. Name






Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 886 , Y Position = 601 , Width = 615 , Height = 427


Under Format ->  Data Colors = click on the letters fx ->  Format by = Color Scale , Based on field = .AVG_AptUnitPrice_PerSqFt , Minimum = Custom = Lowest Value and color = #A0A7D8, check Diverging, Middle Value and color = ##414FB1, Maximum Value and color = ##09124F

Under Format ->  Category = OFF

Under Format ->  Bubbles ->  Size = 45

Under Format ->  Map Controls ->  Auto Zoom = ON , Zoom buttons = ON

Under Format ->  Title ->  Set it to ON, Title Text = Apartment Zip Code , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 19 pt

Under Format ->  Background ->  Set it to ON , Color = #FFFFFF

Under Format ->  Border ->  Set it to ON , Color = #666666 , 5 px



When finished, save project.






Best practice rules to improve your model’s performance